Mega Code Archive - MSOfficeExcel 2007 Tutorial

Editing
1) Access an FTP Site
2) Add a Signature Line
3) Add or Edit an AutoCorrect Entry
4) Add or Modify FTP Locations
5) Change an Excel Template
6) Change AutoFormat options
7) Change Display View Options
8) Change Edit Options
9) Change editing options
10) Change Office Clipboard options
11) Change Research Options
12) Change Smart Tag Options
13) Change Spelling Options for All Microsoft Programs
14) Change the default file location of the Open dialog box
15) Change the Hyperlink Cell Style
16) Change the number of recently opened files that appear on the Office menu
17) Change the text or graphic for a hyperlink
18) Check Spelling All at Once
19) Choose how to fill the selection
20) Clear Cell Contents, Formatting, and Comments
21) Close a Workbook
22) Copy and Paste Data to the Office Clipboard
23) Copy Data Using Drag-and-Drop
24) Copy Data Using the Clipboard
25) Copy or move a hyperlink
26) Create a Custom Fill
27) Create a custom ScreenTip for a hyperlink
28) Create a Link Between Worksheets or Workbooks
29) Create a Link to Another File
30) Create a Template
31) Create a Workbook with a Template
32) Creating a Hyperlink
33) Customize Advanced Properties
34) Delete a Cell
35) Edit Cell Contents
36) Edit cell contents using the formula bar
37) Enter a Date
38) Enter a Label Using AutoComplete
39) Enter a Number as a Label
40) Enter a Text Label
41) Enter a Time on a 12-hour clock
42) Entering Values on a Worksheet
43) Entering Values Quickly with AutoFill
44) Excel 2007 Save File Formats
45) Exit Excel
46) Fill with Contents of Adjacent Cells
47) Find and Modify the Exclusion Dictionary
48) Find Cell Contents
49) Find Cells with Conditional Formatting
50) Find Cells with the Same Conditional Format
51) Find or replace cell contents
52) Format a Number Using the Format Cells Dialog Box
53) Format Currency
54) Format Numbers
55) Format numbers in international currencies
56) Format Values as Currency
57) Format Values as Long Date
58) Format Values as Number
59) Go To a Specific Location
60) Insert a Cell
61) Insert a symbol or special character
62) Insert Information Using a Smart Tag
63) Keys For Navigating in a Worksheet
64) Lock or Unlock Worksheet Cells
65) Long Date Format
66) Make a selection from within a range
67) Move Data Using Drag-and-Drop
68) Move Data Using the Clipboard
69) Open a Recently Opened Workbook
70) Open a Template
71) Open a Workbook from the Excel Window
72) Paste Cells from Rows to Columns or Columns to Rows
73) Paste Data with Special Results
74) Percentage Format
75) PinUnpin a workbook
76) Quickly clear contents
77) Redo an Action
78) Remove a Hyperlink
79) Remove a numeric format or font attribute
80) Replace Cell Contents
81) Research a topic
82) Save a Workbook as a PDF Document
83) Save a Workbook as an XPS Document
84) Save a Workbook for Excel 2007
85) Save a Workbook with Another Format
86) Save an Excel 97-2003 Workbook
87) Scientific Format
88) Search for a value or data in a cell and replace it
89) Select a Contiguous Range
90) Select a Non-contiguous Range
91) Select an Entire Rows or Columns
92) Select Multisheet Ranges
93) Set Save Options
94) Short Date Format
95) Sign the Signature Line
96) Start a Blank Workbook Within Excel
97) Switch Between Views
98) To create a custom number format using the Format Cells Dialog Box
99) To disable AutoRecover for a specific workbook
100) To turn on the AutoComplete option
101) Turn On AutoCorrect
102) Undo an Action
103) Use a Custom Dictionary
104) Use AutoRecover
105) Use the Thesaurus
106) View and Edit Standard Workbook Properties
107) When you press Enter, the active cell moves down one cell To change the direction